/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package db;

import Control.DataManager;
import Model.Terms;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

/**
 *
 * @author Jayson Kiong
 */
public class PrecompServlet extends HttpServlet {

    /** 
     * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    
    private DataManager dataManager;
    private ArrayList types;
   

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** 
     * Handles the HTTP <code>GET</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
            doPost(request, response);
    }

    /** 
     * Handles the HTTP <code>POST</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
            
        
        dataManager = new DataManager();
        dataManager.setServletContext(this.getServletContext());
        Terms term = new Terms();
        types = new ArrayList();
        Connection con = DBConnector.connect();
        types = dataManager.getTypes();
        PreparedStatement ps;
        try {
            ps = con.prepareStatement
          ("Select less_ui,service_charge,notary_fee,evat,docs,collectionfee,"
          + "processingfee,bank_charge,lbc_charge,cashbound from terms where clienttype='Widow' and subtype='New' and loantype='Pension'"); 
                ResultSet rs = ps.executeQuery();
                while(rs.next())
                {
                    
                    term.setfLessui(rs.getFloat("less_ui"));
                    term.setfServicecharge(rs.getFloat("service_charge"));
                    term.setfNotaryfee(rs.getFloat("notary_fee"));
                    term.setfEvat(rs.getFloat("evat"));
                    term.setfDocs(rs.getFloat("docs"));
                    term.setfCollectionfee(rs.getFloat("collectionfee"));
                    term.setfProcessingfee(rs.getFloat("processingfee"));
                    term.setfBankcharge(rs.getFloat("bank_charge"));
                    term.setfLbccharge(rs.getFloat("lbc_charge"));
                    term.setfCashbound(rs.getFloat("cashbound"));
                    
                    }
        HttpSession session = request.getSession(true);   
        session.setAttribute("types", types);
        session.setAttribute("terms", term );
        RequestDispatcher dispatcher = request.getRequestDispatcher("/precomputation.jsp");
        dispatcher.forward(request, response);
        
    }catch(Exception e){
        
    }
    }
    /** 
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>
}
